Home
Knowledge Areas
SQL (Dynamics)
AA
Analytical Account GL Detail query
Analytical Accounting Subledger Query
dd_SOP10100_INS_AA
CM
dd_CM00100_SEL_byActindx
Company/System
dd_DropLogin
dd_SY01100_SEL_byPostingAcctDesc
dd_SY40100_getEarliestOpenPeriod
Dynamics GP SQL Security
Dynamics User Security report
Financial Period Start and End dates
Function to get the fiscal period end date
Log SA access and send an email
SQL Logins, and the databases they have access to.
SQL Security queries
SQL Security query
The selected company is not configured as a company
Extender
ddf_GetExtenderFieldID2
Extender Template Query - Start here
Functions to get the Field_ID for Extender fields
INSERT/UPDATE Extender data
General
Decrypt Dynamics GP Password
Dynamics GP Table Definition Primer
Find users that do not have a database login
Format a field with a currency amount
GetNumbeNumber
Getting Email addresses from Dynamics GP
How to change the DB Collation for a Dynamics GP server
How to decrypt GP (or any, really) Stored Procedures
How to get data from Dynamics GP
Parse a Comment Text field (CMMTTEXT)
Retrieving OLE documents in GP2016 and greater
Run a script against all Dynamics GP company databases
GL
A/P Distribution to GL - when using Intercompany
Generate a GL running sum for a specific year and account
GL and DTA
GL Template Query - Start here
Move GL recurring batches from TEST to LIVE
taGetNextJournalEntry
HR
Direct Deposit Advice report
IV
dd_IV00101_SEL_inRangesOf100
FIFO/LIFO Pricing Walkthrough
Get Item Price function
Insert missing lines in the Item Class Master IV40400
Inventory Running Total
InventoryTransactions standard view
IVTransferType Wrapper
taGetIvNumber - How to get the next IV number using the Stored Procedure
taIVTransactionType Wrapper with Serials
taIVTransferHeaderInsert
taUpdateCreateItemRcd Wrapper
Updating Inventory for 1 or All Items
Updating the DECPLCUR (Decimal Place Currency) in Dynamics GP
Manufacturing
BOM query
Olympic PC
Budget vs Actual query
Certified Payroll report that adds in (Olympic) Project Cost data
Task Levels query
PM
A/P Distribution to GL - when using Intercompany
All Vendors that do not have a record in the transactional tables
dd_PMApply_SEL
dd_PMVendorDocument_SEL
ddf_CommaSeparatedPOs
ddf_CommaSeparatedReceipts
ddv_PayablesWithPOs
insert missing lines in the Vendor Master PM00200
Move a debit and credit to history
seePMAgedTB
seepmHATBWrapper
Stored procedure that mimics the Payables Inquiry 'Re-create check stub' button
taGetPMNextVoucherNumber usage example
taPMDistributionCreate
taPMTransacitonInsert wrapper
taPMTransactionInsert
taPMTransactionInsert Wrapper, including distributions
POP
ddf_CommaSeparatedPOs
ddf_CommaSeparatedReceipts
ddtaPOPTransactionTypeWrapper
ddv_PayablesWithPOs
Function to return all POs on a Contract
Linking a PO to its Voucher
tdd_POP10300 Deferred Revenue Insert
Trigger to copy user defined fields from a POP Requisition to a PO Line
Post Master
Allowing a series to resume posting
PP (Def Revenue)
dd_DeferredPayments_INS - Deferred Revenue template
RM
Apply all available RM documents
AR Historical Aging - Add a Parameter
AR Historical Aging Raw Script
AR Historical Aging Summary Report
dd_RM00101_SEL
dd_RM00101_SEL_byID
dd_RMSalesByMonth
dd_Top10CustomersByYear
Getting Email addresses from Dynamics GP
I need to apply a payment to an invoice via code.
Inactivate customers that have not been invoiced in xx days
RM Transactions with Distributions
seeRMAgeTrailBalance
seermHATBSRSWrapper - how to call and add extra fields
taCalcDueDateRM
taCreateCustomerAddress Wrapper
taRMApply Wrapper
taRmApplyPost for Project Cost apply integrations
taRMTransaction wrapper
taUpdateCreateCustomerRcdWrapper
View that shows number of invoices paid per month and if they were paid late
SM
smGetNextNoteIndex
SOP
dd_SOPRound - Round a SOP Multicurrency document to two decimal places
dd_taSopVoidDocumentWrapper
ddf_Address
ddf_AllHoldsOnASOPDoc
Getting Email addresses from Dynamics GP
SOP40200 'Allow' fields query
sopTrxDeleteWork
taSopDeleteDocumentWrapper
taSopLineDelete
taSopLineDeleteWrapper
taSOPLineIvcInsert Wrapper
taSopLineIvcInsertComponent
taSOPLotAuto - complete procedure
Unvoid a SOP document
SY
Opening and Closing Periods with SQL
SY03900 - Get the next item note index
TA
taCalcDueDatePM
taCalcDueDateRM
taParseCommentText
TAX
UPR
Certified Payroll Report
dd_BonusCalc
dd_PayrollDetail
dd_PayrollHeader
dd_UPR00100_SEL_cbo
ddv_401k
Update an employee's max deduction after turning 50
RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences